package dbAdapter;

import android.content.Context;
import android.database.Cursor;

public class CreateFoodData {
	public void create(Context ctx){
		FoodDBAdapter fdDBAdapter = new FoodDBAdapter(ctx);
		fdDBAdapter.open();
		Cursor fetchFoodCursor = fdDBAdapter.fetchNutrition("Banana");
		if (fetchFoodCursor.getCount() == 0) {
			fdDBAdapter.insertFoodData("Snack","Apple","1","218","0.17g","-","-","-","13.81g","2.4g","10.39g","0.26g","6mg","3ug","0.041mg","4.6mg","0.12mg");
			fdDBAdapter.insertFoodData("Snack","Banana","1","371","0.33g","-","-","-","2.84g","2.6g","12.23g","1.01g","5mg","3ug","0.0367mg","8.7mg","0.26mg");
			fdDBAdapter.insertFoodData("Breakfast","Bagel","1","146","0.17g","-","-","255mg","29g","1g","3g","6g","1%","-","-","-","19%");
			fdDBAdapter.insertFoodData("Breakfast","Wheat Bread","1","66","1g","-","-","130mg","12g","1g","1g","1g","4%","-","-","-","5%");
			fdDBAdapter.insertFoodData("Snack","Popcorn","1","31","-","-","-","1mg","6g","1g","0g","1g","-","-","-","-","1%");
			fdDBAdapter.insertFoodData("Breakfast","Cheerios","1","103","2g","-","-","186mg","21g","3g","1g","3g","11%","16%","-","11%","49%");
			fdDBAdapter.insertFoodData("Snack","Pretzels","1","227","2g","-","-","814mg","48g","2g","2g","6g","1%","0%","-","0%","17%");
			fdDBAdapter.insertFoodData("Snack","Cheesesticks","1","360","16g","5g","25mg","830mg","42g","2g","4g","15g","20%","15%","-","0%","15%");
			fdDBAdapter.insertFoodData("Breakfast","Oatmeal","1","218","0.17g","-","-","-","13.81g","2.4g","10.39g","0.26g","6mg","3ug","0.041mg","4.6mg","0.12mg");
			fdDBAdapter.insertFoodData("Breakfast","English Muffin","1","127","1g","0g","0mg","281mg","26g","3g","1g","5g","10%","0%","-","0%","9%");
			fdDBAdapter.insertFoodData("Lunch","Sandwich","1","371","0.33g","-","-","-","2.84g","2.6g","12.23g","1.01g","5mg","3ug","0.0367mg","8.7mg","0.26mg");
			fdDBAdapter.insertFoodData("Lunch","Cheeseburger","1","300","12g","-","40mg","750mg","33g","2g","6g","15g","20%","6%","-","2%","15%");
			fdDBAdapter.insertFoodData("Lunch","Chipotle BBQ","1","260","0.17g","-","-","-","13.81g","2.4g","10.39g","0.26g","6mg","3ug","0.041mg","4.6mg","0.12mg");
			fdDBAdapter.insertFoodData("Lunch","VegeSalad","1","85","3.5g","0.3g","-","256.25mg","11.73g","2.53g","2.33g","29.5g","7.25%","12.25%","7.14%","37.75%","3.25%");
			fdDBAdapter.insertFoodData("Dinner","Cheese Pizza","1","140","3.2g","1.5g","9mg","336mg","20.5g","-","-","7.7g","12%","8%","-","2%","3%");
			fdDBAdapter.insertFoodData("Dinner","Ramen Noodles","1","218","0.17g","-","-","-","13.81g","2.4g","10.39g","0.26g","6mg","3ug","0.041mg","4.6mg","0.12mg");
			fdDBAdapter.insertFoodData("Dinner","Chowmein","1","237","13.8g","2.0g","0mg","198mg","25.9g","1.8g","0.1g","3.8g","1%","0%","-","0%","12%");
			fdDBAdapter.insertFoodData("Dinner","Friedrice","1","218","0.17g","-","-","-","13.81g","2.4g","10.39g","0.26g","6mg","3ug","0.041mg","4.6mg","0.12mg");
			fdDBAdapter.insertFoodData("Dessert","Vanilla Icecream","1","150","3.5g","2g","15mg","60mg","24g","0g","18g","4g","10%","6%","0%","0%","2%");
			fdDBAdapter.insertFoodData("Dessert","Apple pie","1","218","0.17g","-","-","-","13.81g","2.4g","10.39g","0.26g","6mg","3ug","0.041mg","4.6mg","0.12mg");
			fdDBAdapter.insertFoodData("Dessert","Strawberry Sundae","1","280","6g","4g","25mg","95mg","49g","1g","45g","6g","20%","10%","-","4%","2%");
			fdDBAdapter.insertFoodData("Dessert","FruitnYogurt","1","160","2g","1g","5mg","85mg","31g","1g","21g","4g","15%","0%","-","13%","4%");
			fdDBAdapter.insertFoodData("Beverages","Coke","1","210","-","-","-","15mg","58g","0g","58g","0g","0%","0%","0%","0%","0%");
			fdDBAdapter.insertFoodData("Beverages","Sprite","1","210","-","-","-","55mg","56g","0g","56g","0g","0%","0%","0%","0%","0%");
			fdDBAdapter.insertFoodData("Beverages","Orange juice","1","150","0g","0g","0mg","0mg","30g","0g","30g","2g","2%","0%","-","140%","0%");
			fdDBAdapter.insertFoodData("Beverages","Water","1","0","0g","0g","0g","0mg","0g","0g","0g","0g","0%","0%","0%","0%","0%");
			fdDBAdapter.insertFoodData("Beverages","Apple juice","1","100","0g","0g","0mg","15mg","23g","0g","220g","0g","10%","0%","-","100%","0%");
			
		}
		fetchFoodCursor.close();
		fdDBAdapter.close();
	}

}
